Strongly Possible Functional Dependencies for SQL

نویسندگان

چکیده

Missing data is a large-scale challenge to research and investigate. It reduces the statistical power produces negative consequences that may introduce selection bias on data. Many approaches handle this problem have been introduced. The main suggested are either missing values be ignored (removed) or imputed (filled in) with new values. This paper uses second method. Possible worlds possible certain keyswere introduced in Köhler et.al., by Levene et.al. Link functional dependencies (c-FD) as natural complement Lien's class of (p-FD). Weak strong were studied Loizou. We intermediate concept strongly obtained imputing already existing table preceding paper. results keys (spKey's) (spFD's). give polynomial algorithm verify single spKey show general, it NP-complete an arbitrary collection spKeys. graph-theoretical characterization validity given spFD X →sp Y.We show, complexity dependency then we some cases when verifying can done time.As step forward axiomatization spFD's, rules for weak checked. Appropriate weakenings those not sound spFD's listed. interaction between spKey's studied. Furthermore, graph theoretical implication singular attribute given.

برای دانلود باید عضویت طلایی داشته باشید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Design by Example for SQL Tables with Functional Dependencies

An Armstrong relation satisfies the functional dependencies (FD) implied by a given FD set and violates all other FDs. Therefore, they form an instance of the design-by-example methodology: the example relation exhibits precisely those FDs that the current design perceives as meaningful for the application domain. The existing framework of Armstrong relations only applies to total relations. We...

متن کامل

Probabilistic XML functional dependencies based on possible world model

With the increase of uncertain data in many new applications, such as sensor network, data integration, web extraction, etc., uncertainty both in relational databases and XML datasets has attracted more and more research interests in recent years. As functional dependencies (FDs) are critical and necessary to schema design and data rectification in relational databases and XML datasets, it is a...

متن کامل

On Strongly First-Order Dependencies

We prove that the expressive power of first-order logic with team semantics plus contradictory negation does not rise beyond that of first-order logic (with respect to sentences), and that the totality atoms of arity k + 1 are not definable in terms of the totality atoms of arity k. We furthermore prove that all first-order nullary and unary dependencies are strongly first order, in the sense t...

متن کامل

Functional Dependencies for XML

In this paper we address the problem of how to extend the deenition of functional dependencies (FDs) in incomplete relations to XML documents. An incomplete relation is said to strongly satisfy a FD if every completion of the relation, obtained by replacing all null values by data values, satisses the FD in the ordinary sense. We propose a syntactic deenition of strong FD satisfaction in a XML ...

متن کامل

Possible and Certain SQL Key

Driven by the dominance of the relational model, the requirements of modern applications, and the veracity of data, we revisit the fundamental notion of a key in relational databases with NULLs. In SQL database systems primary key columns are NOT NULL by default. NULL columns may occur in unique constraints which only guarantee uniqueness for tuples which do not feature null markers in any of t...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

ژورنال

عنوان ژورنال: Acta Cybernetica

سال: 2022

ISSN: ['2676-993X', '0324-721X']

DOI: https://doi.org/10.14232/actacyb.287523